SELECT T.* FROM C1_DICTIONARY t
join C1_DICTIONARY_TYPE  t_DICTIONARY_TYPE on (t_DICTIONARY_TYPE.id = t.type_id)
where SYSDATE BETWEEN T.BEGIN_DATE AND T.END_DATE
AND SYSDATE BETWEEN t_DICTIONARY_TYPE.BEGIN_DATE AND t_DICTIONARY_TYPE.END_DATE
AND t_DICTIONARY_TYPE.ID = :typeId
order by t.ORDER_NUM